package com.libaoxuan.blog.dao.mapper;

import com.libaoxuan.blog.dao.dos.Archives;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ArchivesMapper {

    @Select("SELECT YEAR( create_date ) AS YEAR,MONTH ( create_date ) AS MONTH,count(*) AS count FROM ms_article GROUP BY YEAR,MONTH")
    List<Archives> listArchives();

}
